SQLite Foreign Key Support
from
SQLiteドキュメント
SQLite Foreign Key Support
https://www.sqlite.org/autoinc.html